<h1 class="top">Insert</h1>
<h2>The block</h2>
<img src="help/img/insert.png" alt="Insert Block" class="leftFloatIMG">
<p class="leftFloat left">
    The insert block is the block you want to choose, if you want to insert values in your database. It symbolises the insert structure.
    Blocks, like tables and operators are plugged in it.<br> It also can be mutated.<br>
    If you want to learn more about how to mutate the block please, see <a href="#func" class="groupLinks"> 'Functionality'</a>.<br>
    The not mutated select has one input in the 'INTO'-section. 
    This block also changes the colour, to symbolise <a href="#type" class="groupLinks">the types</a> used in SQL.
</p>
<h2 id="func" style="margin-top: 15px;">Functionality</h2>
<p class="text"> To mutate the block, you click on the 
    <span style="color: #A00;">star-icon</span> and a new workspace appears.<br/></p>
<img src="help/img/insert_mutate.png" alt="How to mutate the insert Block" class="img" >
<p class="text">In this workspace you can drop blocks into an 'ADD'-block to expand the insert-block. 
    So for each droped block one new input appears. Like you see in the picture above.<br/>
    If you want to reduce the number of inputs, you click on the star icon and pull the blocks out of the 'ADD' block.<br/>
    The block in this workspace symbolises the<a href="#set" class="groupLinks">'INTO' statement</a>. 
    In the section <a href="#state" class="groupLinks"> 'Statement'</a> you will learn more about them.
</p> 
<h2 id="state" style="margin-top: 15px;">Statement</h2> 
<p class="text"> In the mutator workspace there ist one block symbolising the 'INTO'-statement in SQL.
</p>
<h3 id="gb"> INTO </h3>
<img src="help/img/insert_set.png" alt="Group by" class="img" style='margin-top:10px'>
<p class="text"> The 'INTO' input uses the <span class="groupLinks pointer" onclick="fetchthelink('Help/compare_operator.html', '#5aa68c');"> compare operator</span>.
    Into the first input of the compare operator, you need to plug in the tables and columns value, used here as the insert destination. 
    As second input value your need a value, corresponding in type and colour to the first input.
    <br> This is shown in the picture above. Be sure to use <span style="font-weight: bold;">only</span> 
    tables and columns you use in the 'INSERT'-section,<br>
    otherwise there will be a warning. <br> Be sure the you use only the same table in the insert Block. 
    The usage of different Tables is <span style="font-weight: bold;">not</span> provided.</p>

<h2 id ="type" style="margin-top: 25px;">The types</h2>
<img src="help/img/insert_list.png" alt="Type list" class="img" style="margin-top: 10px;">
<p class="text"> This colour gradient, apple green to cyan, symbolises a list of columns of the database</p>
<img src="help/img/insert_int.png" alt="Type numeric" class="img" >
<p class="text"> This colour gradient, violet to cyan,  symbolises the numeric values of the database</p>
<img src="help/img/insert_text.png" alt="Type text" class="img">
<p class="text"> This colour gradient, brown to cyan, symbolises the textual values of the database</p>
<img src="help/img/insert_date.png" alt="Type date" class="img">
<p class="text"> This colour gradient ,tapestry to cyan, symbolises the date values of the database</p>
<img src="help/img/insert_bool.png" alt="Type bool" class="img">
<p class="text"> This colour ,cyan, symbolises the boolean values of the database</p>
<div id="aliasback"></div>